First-Last function

To apply functions like:

§          First N, Last N                                        MDX Head, MDX Tail

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

for axis function you need to

§          … right-click inside row or column area

§          … select Axis functions menu

then select

§          … First or Last  function from submenu

 

 

In our case let us try to get:

 

last 10 member from level City of hierarchy hCountry

 

Dialog will appear:

 

 

§          select appropriate value (5 in our case)

§          select OK

 

After confirmation result is: